PGA memory operation
Short Description
Undocumented. Waiting on allocation or deallocation of operating system memory in the Program Global Area.
Detailed Description​
Undocumented. A new event for Oracle 12.2 ‘PGA memory operation’ covers the allocation or deallocation of PGA memory. This will happen for instance when a direct path read is performed and the contents of the buffer are written to private memory rather than the buffer pool.
How to reduce this wait​
This is a normal activity. If this wait is excessive, consider tuning the query to do less work.
Additional Links​
Ask Tom - wait event - PGA memory operation
Fritz Hoogland Blog - Oracle 12.2 wait event ‘PGA memory operation’
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.